Release 10.1A: OpenEdge Development:
Debugging and Troubleshooting

Sample Query Info logs

Shown below are sample output formats (with headers suppressed) of Query Info logs.

The following is a code example for a non-pre-pass query: 

FOR EACH invoice  
  WHERE ((invoice.ordernum >= 102) AND  
         (invoice.custnum >= 28 AND invoice.custnum <= 30) AND 
         (invoice.invoicenum > 100 AND invoice.invoicenum <= 105)) OR 
        ((invoice.ordernum > 118 AND invoice.ordernum <= 119) AND 
         (invoice.custnum = 46) AND 
         (invoice.invoicenum > 115 AND invoice.invoicenum < 120)) OR 
        (invoicenum = 136), 
  EACH order WHERE order.ordernum = invoice.ordernum : 
    DISPLAY invoice.invoicenum order.ordernum. 
END.

The following is an example of the query plan for a non-pre-pass query: 

Query Plan:  qisample1.p line 1 
QueryId: 0x159e004 
Type: FOR Statement 
Client Sort: N  
Scrolling: N 
Table: sports2000.Invoice 
  Indexes: InvoiceNum,CustNum 
Table: sports2000.Order 
  Indexes: OrderNum

The following is example of the query statistics for a non-pre-pass query: 

Query Statistics:  qisample1.p line 11 
QueryId: 0x159e004 
DB Blocks accessed: 
 sports2000 : 43 
DB Reads: 
 Table: sports2000.Invoice : 11 
 Index: Invoice.InvoiceNum : 8 
 Index: Invoice.CustNum : 6 
 Table: sports2000.Order : 3 
 Index: Order.OrderNum : 6 
sports2000.Invoice Table: 
 4GL Records: 3 
 Records from server: 3 
  Useful: 3 
  Failed: 0 
 Select By Client: N 
sports2000.Order Table: 
 4GL Records: 3 
 Records from server: 3 
  Useful: 3 
  Failed: 0 
 Select By Client: N

The following is a code example for a pre-pass query: 

FOR EACH invoice  
  WHERE ((invoice.ordernum >= 102) AND  
         (invoice.custnum >= 28 AND invoice.custnum <= 30) AND 
         (invoice.invoicenum > 100 AND invoice.invoicenum <= 105)) OR 
        ((invoice.ordernum > 118 AND invoice.ordernum <= 119) AND 
         (invoice.custnum = 46) AND 
         (invoice.invoicenum > 115 AND invoice.invoicenum < 120)) OR 
        (invoicenum = 136), 
  EACH order WHERE order.ordernum = invoice.ordernum  
  BY invoice.custnum : 
    DISPLAY invoice.invoicenum order.ordernum. 
END.

The following is an example of the query plan for a pre-pass query: 

Query Plan:  qisample2.p line 1 
QueryId: 0x159e006 
Type: FOR Statement 
Client Sort: Y  
Scrolling: N 
Table: sports2000.Invoice 
  Indexes: CustNum,InvoiceNum 
Table: sports2000.Order 
  Indexes: OrderNum

The following is an example of the query statistics for building the result-list on a pre-pass query: 

QueryId: 0x159e006 
Entries in result list: 3 
Time to build result list (ms): 16 
DB Blocks accessed to build result list: 
 sports2000 : 38 
DB Reads to build result list: 
 Table: sports2000.Invoice : 15 
 Index: Invoice.CustNum : 16 
 Index: Invoice.InvoiceNum : 2 
 Table: sports2000.Order : 0 
 Index: Order.OrderNum : 0 
sports2000.Invoice Table: 
 Records from server: 3 
  Useful: 3 
  Failed: 0 
 Select By Client: N 
sports2000.Order Table: 
 Records from server: 0 
  Useful: 0 
  Failed: 0 
 Select By Client: N

The following is an example of the second query statistics (record retrieval) on a pre-pass query: 

Query Statistics:  qisample2.p line 12 
QueryId: 0x159e006 
DB Blocks accessed: 
 sports2000 : 15 
DB Reads: 
 Table: sports2000.Invoice : 3 
 Index: Invoice.CustNum : 0 
 Index: Invoice.InvoiceNum : 0 
 Table: sports2000.Order : 3 
 Index: Order.OrderNum : 6 
sports2000.Invoice Table: 
 4GL Records: 3 
sports2000.Order Table: 
 4GL Records: 3

The following is an example of the query statistics when the read access statistics for the table and index are outside of range: 

Query Statistics:  idxnum.p line 6 
QueryId: 0x159f3ec 
DB Blocks accessed: 
  sports2004 : 272 
DB Reads: 
  Table: sports2004.item : UNAVAILABLE 
  Index: item.Item_Obj : UNAVAILABLE 
sports2004.item Table: 
  4GL Records: 134 
  Records from server: 134 
   Useful: 134 
   Failed: 0 
Select By Client: N

Copyright © 2005 Progress Software Corporation
 www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095